﻿# MySQL-Front 5.1  (Build 3.18)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;


# Host: localhost    Database: openshop
# ------------------------------------------------------
# Server version 5.1.35-community

#
# Source for table open_purchase_return_order
#

DROP TABLE IF EXISTS `open_purchase_return_order`;
CREATE TABLE `open_purchase_return_order` (
  `order_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `order_sn` varchar(60) NOT NULL DEFAULT '',
  `supplier_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `depot_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `seat_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `discount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `deliver_time` int(10) unsigned NOT NULL DEFAULT '0',
  `goods_number` smallint(5) unsigned NOT NULL DEFAULT '0',
  `order_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `order_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `order_brief` tinytext NOT NULL,
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`order_id`),
  UNIQUE KEY `order_sn` (`order_sn`),
  KEY `depot_id` (`depot_id`),
  KEY `seat_id` (`seat_id`),
  KEY `supplier_id` (`supplier_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

#
# Dumping data for table open_purchase_return_order
#
LOCK TABLES `open_purchase_return_order` WRITE;
/*!40000 ALTER TABLE `open_purchase_return_order` DISABLE KEYS */;

INSERT INTO `open_purchase_return_order` VALUES (1,'th796094460',1,0,0,8.1,1258430400,0,0,0,'twetqqtqwtw7',1257393600);
INSERT INTO `open_purchase_return_order` VALUES (2,'th468584408',1,0,0,8,1260331200,0,0,0,'8768967978',1257652800);
/*!40000 ALTER TABLE `open_purchase_return_order` ENABLE KEYS */;
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
